#! /bin/bash

for i in dwd_action_log dwd_cart_info dwd_comment_info dwd_coupon_use dwd_display_log dwd_error_log dwd_favor_info dwd_order_detail dwd_order_info dwd_order_refund_info dwd_page_log dwd_payment_info dwd_refund_payment dwd_start_log dws_activity_info_daycount dws_area_stats_daycount dws_coupon_info_daycount dws_sku_action_daycount dws_user_action_daycount dws_visitor_action_daycount dwt_activity_topic dwt_area_topic dwt_coupon_topic dwt_sku_topic dwt_user_topic dwt_visitor_topic
do
	hive -e "alter table gmall.$i drop partition (dt ='2020-06-18');"
done
